Laravel And JqueryUI's Autocomplete Plugin

autocomplete.php

//SearchController.php
public function autocomplete(){
	$term = Input::get('term');
	
	$results = array();
	
	$queries = DB::table('users')
		->where('first_name', 'LIKE', '%'.$term.'%')
		->orWhere('last_name', 'LIKE', '%'.$term.'%')
		->take(5)->get();
	
	foreach ($queries as $query)
	{
	    $results[] = [ 'id' => $query->id, 'value' => $query->first_name.' '.$query->last_name ];
	}
return Response::json($results);
}


//View
{{ Form::open(['action' => ['SearchController@searchUser'], 'method' => 'GET']) }}
    {{ Form::text('q', '', ['id' =>  'q', 'placeholder' =>  'Enter name'])}}
    {{ Form::submit('Search', array('class' => 'button expand')) }}
{{ Form::close() }}


//Route
Route::get('search/autocomplete', 'SearchController@autocomplete');


//Javascript
$(function()
{
	 $( "#q" ).autocomplete({
	  source: "search/autocomplete",
	  minLength: 3,
	  select: function(event, ui) {
	  	$('#q').val(ui.item.value);
	  }
	});
});

I have removed jQuery ui 1.11.4 from the code but i have this error
Uncaught TypeError: $(...).autocomplete is not a function
But the title of autocomplete is : Laravel And JqueryUI's Autocomplete Plugin , it is used jquery ui

You just need these two jqueries

jquery-1.9.1.min.js and (query-ui.js or ui 1.11.4.js)

I have user only jquery-1.9.1.min.js and (query-ui.js or ui 1.11.4.js) but no solution for this problème , it is the same
this my index.blade.php

``` @extends('layouts.app')`

@section('content')

Dashboard

            </tbody>
        </table>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/ui/1.11.4/jquery-ui.min.js"></script> <script type="text/javascript"> /*$(document).ready(function(){ var route = "{{ URL('/employees') }}"; $.get(route, function(res){ $(res).each(function(key, value){ $('#data').append(""); }); }); });*/ </script> <script type="text/javascript" > $('document').ready(function(){ /* $('#search-input').attr('autocomplete', 'on');*/ $("#search-input").autocomplete({ source : '{{ URL('/api/employees') }}', minlength: 1, autoFocus: true, /* select: function(event,ui){ console.log("nouar"); $('#search-input').val(ui.item.value); $('#employee_N').val(ui.item.employee_N); $('#first_name').val(ui.item.first_name); $('#last_name').val(ui.item.last_name); $('#status').val(ui.item.status); }*/ }); }); </script>

@endsection

E. Number	Firstname	Lastname	Title	Direction	Recruitment date	Grade
"+value.employee_N+"	"+value.frst_name+"	"+value.last_name+"	"+value.title+"	"+value.direction+"	"+value.recruitment_date+"	"+value.grade+"

Please use this code , this is your updated code and make sure your route and controller have no error

<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/themes/base/minified/jquery-ui.min.css" type="text/css" />

$('document').ready(function(){
/* $('#search-input').attr('autocomplete', 'on');*/
$("#search-input").autocomplete({
source : "{{ URL('/api/employees') }}",
minlength: 1,

       select: function(event,ui){

           $('#search-input').val(ui.item.value);

            }
    });

});

with these changes its perfectly working for me

Please take a look at select2 it will get the job easier for you, if u need more help just let me know
https://select2.github.io/examples.html

it's work but how can I get the id value after selecting data. I tried $('.').on('change', function()) but it doesn't work. What function I should use?

I mean i am getting data like this

[{"id":176,"value":"MYKONOS AIRPORT(JMK) => CENTRAL MYKONOS"},{"id":180,"value":"MYKONOS AIRPORT(JMK) => CENTRAL MYKONOS"},{"id":588,"value":"KUSADASI => BODRUM"},{"id":589,"value":"BODRUM => KUSADASI"},{"id":596,"value":"KUSADASI => CESME"},{"id":597,"value":"CESME => KUSADASI"},{"id":598,"value":"KUSADASI => DIDIM"},{"id":610,"value":"KUSADASI => ANTALYA"},{"id":611,"value":"ANTALYA => KUSADASI"},{"id":612,"value":"KUSADASI => FETHIYE"},{"id":1194,"value":"KUSADASI => BODRUM"},

Although data is correct but ofcourse i want it when user searches for anything

Works perfectly!!!!!

perfect thanks

That's perfect script.
thanks

After one week I solve my problem with your nice and clean code. YOU ARE LEGEND! Thank you.

How to send id in value not actual text.
Even i have updated this:
$('#customer_name').val(ui.item.value);
to
$('#customer_name').val(ui.item.id);
but still posting value instead customer id.

html:
<input type="text" class="form-control" id="customer_name" name="customer_name" placeholder="Enter name">

Please help me.

Thanks a lot !!!

In Laravel 5.2
$term = Request::get('q'); is working.
use Request;
and if you want to use 'Illuminate\Http\Request' (Request Object) then type the line use Illuminate\Http\Request; and write
public function autoComplete(Request $request){ $term = $request->get('q');

Thanks, it is verry helpfull

I am using Laravel 5.2 and have done as per above. When I type something in text box it shows all result set not the particular result. Could you please help in this regard ?

great !!

I am trying to make this work on Laravel 5.4 basic differences with the original is using Request instead of Input and response()->json($results) intead of Response::json

My text field send the request to the route and I got a 200 response (and if a see it on the browser is correct), but I am getting this error on the console:
TypeError: elem.getClientRects is not a function

And is not displaying the options.

Please advice

EDIT: That error was coming from using jquery-ui-bundle (because somehow jquery-ui is not Mix friendly) and bundle is stuck on 1.11.x and that won't work with jquery 3.x. Solved by placing jquery-ui manually on resources.

Now all seems to work, except there is not displaying of options whatsoever

@gassius This code can actually be simplified quite a bit, here is my implementation with Laravel 5.4. No need for foreach looping through the data.

SearchController.php:

public function autocomplete()
{
	$term = request('term');
        $result = Model::whereName($term)->orWhere('name', 'LIKE', '%' . $term . '%')->get(['id', 'name as value']);
        return response()->json($term);
}

Model and query should be adjusted to search the data source you require, plus a limit with take() if required.

You should also avoid hardcoding the source URL. It can be done like this:

routes/web.php:

Route::get('search/autocomplete', ['as' => 'search-autocomplete', 'uses' => 'SearchController@autocomplete']);

view:

<input type="text" name="term" id="q" data-action="{{ route('search-autocomplete') }}">

We're referencing the action with the route() helper in a data-action attribute, this can now be passed through to the JS file like so:

$('#q').each(function() {
        var $this = $(this);
        var src = $this.data('action');

        $this.autocomplete({
            source: src,
            minLength: 2,
            select: function(event, ui) {
                $this.val(ui.item.value);
                $('#id').val(ui.item.id);
            }
        });
    });

source is assigned the route from data-action, which is defined in our routes file. No need for hard coding urls.

Bonus. I've added a hidden field to the form to capture the ID of the selection

{!! Form::hidden('source_id', ['class' => 'source_id', 'id' => 'source_id']) !!}

source_id should obviously reflect the column name.

Hope this helps

@goodbytes-gb thxx a lot !
Just one thing: where (and how) do you add

{!! Form::hidden('source_id', ['class' => 'source_id', 'id' => 'source_id']) !!}

I am a beginner at laravel

Great script its working fine.

Style it with Bootstrap:
https://stackoverflow.com/questions/17838380/styling-jquery-ui-autocomplete

is very good and very easy.Thank!!! Please someone have one idea about implement a cache too in this code.

@gdbyte's code works perfectly, however, you need to change the SearchController.php code from:
return response()->json($term);
to:
return response()->json($result);

You'll also need to make sure you include jQuery UI in your project, otherwise, you'll get an error saying that the autocomplete function doesn't exist.

Hi, I know i'm late, But i'm doing the same thing and yes it works but man its slow. How do I return the results more faster

@non-entity9 , I am also trying to get @gdbytes code to work:
-created SearchController.php and added his code. Updated model and query
-added route
-added input to view
-not sure where to put the JS file. Where do you put that?

What else do I need to do to get this to work? Thx in advance

Other than plugin, it is also necessary to intetgrate some full text search functionality, like Elasticsearch? I think autocomplete search works well when Elasticsearch is configure in the Laravel model.

Uncaught TypeError: $(...).autocomplete is not a function .........any solutions ?

I noticed that your web page does not include the JS library from jQuery Ui's CSS and JS library.

Firstly, include the following libaries into your web pages:

<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<!-- jQuery UI -->
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<script type="text/javascript">

Checkout this guide: https://www.tutsmake.com/laravel-jquery-ui-autocomplete-ajax-search-example/